2016-09-16 - 28042 - Break Fix - Sales Analysis query formula field #BIExplorer
Break Fix
28042 - sales analysis query formula field
Problem Summary
Need to add new fields gross profit for TY and LY to 'North America Sales Analysis' explorer.
Admin Info
Purpose
|
Need to add new fields gross profit for TY and LY to 'North America Sales Analysis' explorer.
|
Requested by
|
Michael Carducci
|
Issue Date
|
09-16-2016
|
Resolved by
|
Venkateswara Reddy D
|
Resolved Date
|
09-23-2016
|
Document Status
|
Complete
|
Detailed Problem Description
Email from Mark Harris:
Carduccccccci details:
For ‘Sales Analysis with Discounts’ (Priority 1)
Add Field: Royalty Rate (%) at MID level
Add Field: List Price ($) at MID level
Add Field: MSRP Price ($) at MID level
Add Field: Period-Year Concatenated (05-2016)
Increase Export Capacity of Analysis for Excel: 250,000 cells -> 6,500,000 (250k rows by 26 columns)
For ‘North America Sales Analysis’ Explorer (Priority 3)
Add Field: Gross Profit (Shipped Net Revenue – COGS) TY and LY
For the Point of Sale Retail project: (Priority 2)
Man hours necessary to transform and set up current retail files from customers in Business Warehouse and present through to Sales Analysis and Explorer
Cost associated with man hours
Link to examples of files: X:\Budgets\North America Finance\Sell-Through Data
Solution Analysis and Recommendations
1. Need to create two new measures gross profit this year and last year.
2. Need to index the explorer information space.
3. Need to validate the data.
Resolution
1. Created two new measures gross profit this year and last year.
2. Explorer information space indexed and validated.
Release Information
2016-09-16 - 28042 - Rel Notes - sales anlysis query formula field - Release 001